﻿<?xml version="1.0" encoding="utf-8"?>
<Dashboard CurrencyCulture="en-US">
  <Title Visible="false" Text="Độc Giả" />
  <DataSources>
    <SqlDataSource ComponentName="DashboardSqlDataSource1">
      <Name>SQL Data Source_DocGia</Name>
      <Connection Name="ConnectionStringOnline" FromAppConfig="true" />
      <Query Type="StoredProcQuery" Name="load_docgia">
        <ProcName>load_docgia</ProcName>
      </Query>
      <ResultSchema>
        <DataSet Name="SQL Data Source_DocGia">
          <View Name="load_docgia">
            <Field Name="id" Type="Int32" />
            <Field Name="taikhoan" Type="String" />
            <Field Name="matkhau" Type="String" />
            <Field Name="ten" Type="String" />
            <Field Name="hinh" Type="String" />
            <Field Name="gioitinh" Type="Boolean" />
            <Field Name="sdt" Type="String" />
            <Field Name="diachi" Type="String" />
            <Field Name="ngaydk" Type="DateTime" />
            <Field Name="ghichu" Type="String" />
            <Field Name="phanquyen" Type="Int32" />
          </View>
        </DataSet>
      </ResultSchema>
      <CalculatedFields>
        <CalculatedField Name="GioiTinh" Expression="Iif([gioitinh] = True, 'Nam', 'Nữ')" DataMember="load_docgia" />
      </CalculatedFields>
    </SqlDataSource>
  </DataSources>
  <Items>
    <Grid ComponentName="GridDashboardItem1" Name="Thông Tin Cá Nhân" DataSource="DashboardSqlDataSource1" DataMember="load_docgia">
      <DataItems>
        <Dimension DataMember="ten" Name="Họ Và Tên" UniqueName="DataItem0" />
        <Dimension DataMember="ngaydk" SortOrder="Descending" DateTimeGroupInterval="Day" UniqueName="DataItem1" />
        <Dimension DataMember="diachi" Name="Địa Chỉ" UniqueName="DataItem2" />
        <Dimension DataMember="sdt" Name="SĐT" UniqueName="DataItem3" />
      </DataItems>
      <GridColumns>
        <GridDimensionColumn Name="Họ Và Tên" FixedWidth="13.655555917304248" WidthType="FixedWidth">
          <Dimension UniqueName="DataItem0" />
        </GridDimensionColumn>
        <GridDimensionColumn Name="Địa Chỉ" Weight="112.30569948186529">
          <Dimension UniqueName="DataItem2" />
        </GridDimensionColumn>
        <GridDimensionColumn Name="SĐT" Weight="37.694300518134717">
          <Dimension UniqueName="DataItem3" />
        </GridDimensionColumn>
      </GridColumns>
      <SparklineArgument UniqueName="DataItem1" />
      <GridOptions ColumnWidthMode="Manual" />
    </Grid>
    <Chart ComponentName="ChartDashboardItem1" Name="Đăng Ký (Tháng)" DataSource="DashboardSqlDataSource1" DataMember="load_docgia">
      <DataItems>
        <Measure DataMember="taikhoan" Name="Số Lượng (Tài Khoản)" SummaryType="Count" UniqueName="DataItem0">
          <NumericFormat FormatType="Number" Precision="0" Unit="Ones" />
        </Measure>
        <Dimension DataMember="ngaydk" DateTimeGroupInterval="MonthYear" UniqueName="DataItem2" />
        <Dimension DataMember="GioiTinh" UniqueName="DataItem1" />
      </DataItems>
      <SeriesDimensions>
        <SeriesDimension UniqueName="DataItem1" />
      </SeriesDimensions>
      <Arguments>
        <Argument UniqueName="DataItem2" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value UniqueName="DataItem0" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
    </Chart>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical">
      <LayoutItem DashboardItem="GridDashboardItem1" Weight="45.047923322683708" />
      <LayoutItem DashboardItem="ChartDashboardItem1" Weight="54.952076677316292" />
    </LayoutGroup>
  </LayoutTree>
</Dashboard>